Email Us   Phone : 503-259-0312   
  Home    |    Instructor-led Training    |    Online Training     


Contact Us   -   Why Choose Wintrac   -   Clients    

Order CD-ROMs   Order Videos 
MCSE 2000 Elective: SQL Server 7.0 System Administration
with Wayne Snyder


View Course Outline

This Microsoft approved course provides step-by-step preparation to install, configure, administer, and troubleshoot Microsoft SQL Server version 7.0. At the conclusion of this course, you’ll be fully prepared for system administration using Microsoft SQL Server version 7.0, and be prepared to pass MCP exam #70-028.

Course includes 8+ hours of total training time...

  • 5 CDs
  • Over 8 hours of media run time
Format Sessions Price
70-028 Course
CD-ROM

 5 CD-ROMs

$425.00  
Read about Wayne Snyder.
Course Outline (Outlines are subject to change.)

Administering SQL Server 7.0

Sessions Run Time
5 CDs 8 hours

This Microsoft approved course provides step-by-step preparation to install, configure, administer, and troubleshoot Microsoft SQL Server version 7.0. At the conclusion of this course, you’ll be fully prepared for system administration using Microsoft SQL Server version 7.0, and be prepared to pass MCP exam #70-028.

 

SESSION 1
Total Time: 97 Minutes

  • Introduction
  • Installation Planning
  • Installation
  • SQL Enterprise Manager
  • SQL Tools

SESSION 2
Total Time: 105 Minutes

  • Troubleshooting Installation
  • Advanced Installation
  • Upgrade
  • Client Install
  • Creating Databases
  • Database Considerations

SESSION 3
Total Time: 104 Minutes

  • Performance Considerations
  • Managing Databases
  • Security Models
  • Logins & Users
  • Permissions & Roles
  • Applying Permissions & Roles

SESSION 4
Total Time: 106 Minutes

  • Backups
  • Transaction Logs
  • Filegroup Backups
  • Optimizing Backups
  • Restore
  • Backup & Restore
  • Relocating Data

SESSION 5
Total Time: 96 Minutes

  • Replication Overview
  • Configuring Replication
  • Linked Server
  • Automation
  • Alerts & Troubleshooting
  • SQL Mail
  • Monitoring & Optimizing
  • Full Text Search

back to top


Your Instructor

Wayne Snyder is a recognized expert in application development and database design and modeling with specialization in Microsoft SQL Server. Wayne has worked with SQL from its first release, and won the prized Microsoft MVP (Most Valuable Professional) award in 1998. His certifications include MCDBA, MCSE, and MCT. Wayne is a highly respected speaker at industry conferences and a sought-after reviewer for major technical publications. He is a popular instructor and consultant currently working with IKON Education Services.

back to top


 
About us
Contact us
Careers at Wintrac
Our Clients
Why Wintrac


Register for a free training CD-ROM drawing
Refer a client or instructor and earn $$$


Wintrac Inc.
16523 SW McGwire Ct.
Beaverton OR 97007
 
? Wintrac, Inc. All rights reserved.                                                                               Site Map   |   Terms of Use   |   Privacy Policy